DOORS: Import oleTable from excel to doors using DXL script.

hello all,

I am new to doors,

can some one help me how to import ole table form excel to doors using DXL Script.

I am trying this from one month but unable to get solution for this .can some one help me with some solution or some suggestion how to do.

Thanks in advance.

Re: DOORS: Import oleTable from excel to doors using DXL script.
Mathias Mamsch - Fri Apr 27 05:51:30 EDT 2018

I think you need to use copy / paste or  copy / getRichClip (retrieve the contents of the clipboard in richtext) ... There are several posts on Excel automation, like this one:

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014866917&ps=25

So I would try, to open the excel sheet, copy the range to the clipboard and then get the contents of the clipboard and insert them into the object attribute. Regards, Mathias

Re: DOORS: Import oleTable from excel to doors using DXL script.
Naveen_Auto - Wed May 09 03:14:26 EDT 2018

hello Mathias ,

thank you for reply .

I am able to open excel and import into doors but iam not getting how to copy range of cells as table from excel to clipboard . i have seen some function like richTextWithOle and oleMethod in web but iam not getting how copy range of cells to clipboard as table and paste it into  doors object .please help with example 

if i use 

string s = stringOf(richClip)

Table cell looks like:

• {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Tahoma ...

Thanks and regards,

T.Naveen